-- ----------------------------
--  Table structure for `captcha`
-- ----------------------------
CREATE TABLE `captcha` (
  `captcha_id` bigint(13) NOT NULL AUTO_INCREMENT,
  `captcha_time` int(10) unsigned NOT NULL,
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `word` varchar(20) NOT NULL,
  PRIMARY KEY (`captcha_id`),
  KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
CREATE TABLE `user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_nama` varchar(100) NOT NULL,
`user_username` varchar(100) NOT NULL,
`user_password` varchar(100) NOT NULL,
`user_level` int(5) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'Amanda Putri', 'amanda', '827ccb0eea8a706c4c34a16891f84e7b', '1'), ('2', 'Betty Prameswari', 'betty', '827ccb0eea8a706c4c34a16891f84e7b', '2'), ('3', 'Cahya Wulandari', 'cahya', '827ccb0eea8a706c4c34a16891f84e7b', '3');
COMMIT;

-- ----------------------------
-- Table structure for `level`
-- ----------------------------
CREATE TABLE `level` (
`level_id` int(5) NOT NULL AUTO_INCREMENT,
`level_nama` varchar(100) NOT NULL,
PRIMARY KEY (`level_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of `level`
-- ----------------------------
BEGIN;
INSERT INTO `level` VALUES ('1', 'Root'), ('2', 'Administrator'), ('3', 'Operator');
COMMIT;

-- ----------------------------
-- Table structure for `menu`
-- ----------------------------
CREATE TABLE `menu` (
`menu_id` int(11) NOT NULL AUTO_INCREMENT,
`menu_nama` varchar(100) NOT NULL,
`menu_uri` varchar(100) NOT NULL,
`menu_allowed` varchar(100) NOT NULL,
PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of `menu`
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES ('1', 'Manajemen Menu', 'home/manajemen_menu', '+1+'), ('2', 'Manejemen User', 'home/manajemen_user', '+1+2+'), ('3', 'Input Transaksi', 'home/input_transaksi', '+1+2+3+');
COMMIT;
